Overview
What is SQL Developer?
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
Oracle SQL Developer - Free Rool
Great lightweight tool
Oracle SQL Developer the Masterclass for Database Work
One of the fine IDE tool - Oracle SQL Developer
Oracle SQL Developer True Review
Free, simple to use and complete development IDE for Oracle databases
Oracle SQL Developer, a productive tool for Oracle developer
Oracle SQL Developer: One of the best Softwares I Have Ever Used
Easiest SQL IDE
Intuitive and powerful, provides tools and utilities users to handle advanced user requirements
Software for everyone using DB
Must-have SQL editor
Easy to use tool for day to day needs - SQL Developer
SQL Developer Review
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
What is SQL Developer?
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
7 people also want pricing
Alternatives Pricing
What is Rider?
JetBrains supports .NET development with Rider, a .NET IDE based on the IntelliJ platform and ReSharper.
What is The Welkin Suite?
The Welkin Suite offers an integrated development environment with 105 features (and growing). The vendor aims to help you automate the chores of development, and therefore enhance your coding velocity and increase the quality of your deliverable code.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is SQL Developer?
SQL Developer Competitors
SQL Developer Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(489)Attribute Ratings
Reviews
(1-25 of 43)Oracle SQL Developer - Free Rool
- Structure Oracle Database objects
- Intuitive navigation
- Export Data
- Java dependency
- Autocomplete issues
One of the fine IDE tool - Oracle SQL Developer
- The efficient connectivity with various Oracle and relational databases.
- The options for fastest query building and execution. The debugging options also displays exact error message of the query, if any bug in query.
- We can export extracted data in various file formats.
- Simple user interface and effective functions for user friendliness.
- When the connected database is disconnected due to some issues, the re-connection option does not work properly all the time.
- For the long time executions, tool gets unstable state.
- The report and documentation features need to updated.
Oracle SQL Developer True Review
- Better Performance
- Good User interface
- Advance Options
- Big Data
- Syntax
- Intellisense
- Type casting
- Ability to browse across all database components and easily modify or drop them, or create new ones.
- Very simple to use and learn, yet includes many personalization options (like snippets and SQL history)
- You can define window border colors for different connections, thus easily identifying production or sensitive environments at glance!
- Import and Export data in a very simple way
- Being a JAVA application, response times are sometimes not as good as native applications
- Sometimes it uses more RAM than expected
- Sometimes gets disconnected from DB
- Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
- The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
- DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
- Showing more detail on real-time database performance data
- Integration with AWR report
- Show more diagnostic info on Oracle RAC
- [You] can connect multiple databases [very] easily.
- [Anyone] can write [queries] easily and see the errors.
- [It] generates [an] execution plan, which helps to optimize the query.
- [Good] filtering and reporting is not available.
- [More] documentation should be available in software so that user will get all the help in it.
- [Memory] usage should be less.
Easiest SQL IDE
- Very simple UI. Also quite user friendly.
- Debugging seems very easy if there is any issue.
- It's a freeware and easy to install.
- Also does support to connect with various kinds of databases.
- When usage is really heavy, it lags a lot.
- It automatically gets disconnected if haven't used for some amount of time.
- Needs more detailed documentation.
It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.
Intuitive and powerful, provides tools and utilities users to handle advanced user requirements
- Easy interface with large selection of useful utilities.
- Import and export of pre-configured SQL connections for easy duplication.
- Snippets, history, and other utilities add quick custom functionality.
- Some database design tools found in other SQL tools are not yet available.
- Customizing utility windows does not save after restarting application.
Must-have SQL editor
- Database querying SQL
- Data modeling and design
- Database explorer
- Data filtering, export/import
- Database object management
- Data migration
- Debugging
- Version control
- OLAP
- Analytics reports
- Sessions
- Database comparision
- Better user interface
- Native support for other databases
- Autocompletion
- Performance
It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.
Easy to use tool for day to day needs - SQL Developer
- Build and analyze SQL queries by connecting multiple databases.
- User friendly GUI and easy to navigate through various features easily.
- Import data easily from text files, Excel files, and CSV files.
- Easy to install and config.
- It uses lot of system memory.
- Lack of scheduling jobs.
- Export or import data from on-prem to cloud and vice versa easily.
- Nice to have drag and [desktop] feature.
SQL Developer Review
- Ease of writing SQL queries and fine tuning it.
- Very intuitive GUI.
- It's a very heavy tool, and it doesn't work well with low memory computers.
- It's doesn't show users the TNS entries for databases.
Reliable tool for Oracle DBs
- Database manipulation and SQL editing.
- PL/SQL code development.
- Modern IDE like features, like wider linting support.
- More customization.
SQL Developer FOC
- DML and DDL.
- Organization of connections to databases.
- Export and import of external data.
- SQL Developer does most everything TOAD can do.
- Easier way to manipulate packages and procedures.
- Better documentation and location of documentation easier to find online.
- Maybe a little better look and feel to the GUI.
My Oracle SQL Developer Review
- Oracle SQL Developer's navigation bar has a lot of useful tools. When first learning how to use this product, it was very easy to move around and figure out what needed to be done.
- This product allows you to organize schemas on a side bar view, which is very useful when working with multiple databases.
- You can customize schema names to your liking, it does not have to be the same as others on the team.
- Oracle SQL Developer is not the best tool for extracting data. If you want an excel sheet for all the outputted result data, it can take a very long time. This is tough for business users.
- This tool does not allow you to monitor a system that is running as easy as other products similar to it.
- Oracle SQL Developer is not as advanced in functionality as some other tools. For basic developers, this tool gets the job done. For more complex database management, I would suggest other software.
Oracle SQL Developer: nice to work with it!
- Connect to Oracle Databases
- Create database objects like tables, views, triggers, jobs, users, stored procedures, functions.
- Build and execute SQL queries
- Execute SQL scripts
- Easy to install, configure and use.
- You can Import data easily from text files, Excel files, and CSV files.
- Excellent GUI.
- Oracle SQL Developer uses a big amount of RAM.
- You can use it for PL/SQL programming
- You can execute SQL scripts
- You can connect with different databases
SQL developer for dummies
- SQL Developer is easy to navigate and open database structures like tables, packages, procedures, etc.
- Easy to connect to set up database connectivity using service name/SID information.
- SQL Developer UI is very simple to understand and operate by the users and has a quick connect and load time of applications.
- Easy to check the Explain plan assessing the cost of the SQL queries and thus helping in tuning.
- Lacks the advanced options for a professional developer like accessing the dependent objects of a particular database object like Indexes, triggers, etc.
- Lacks features do not have the SQL session monitoring capability and managing other Oracle sessions.
- It does not give a clear indication of query status, whether it is running or stuck.
Great for non-DBA users
- SQL Developer is useful for navigating the DDL of a table.
- Easy-to-understand errors and explanations on incorrect queries.
- Quick load time of application from start-up.
- Explain plans are very helpful in tuning.
- Never know when a query has been truly terminated. Even if one has access to the SQL Monitoring or Monitoring SQL Sessions, it still may show as being terminated but in actuality, within OEM, the query could still be running and need to be killed there. The inability to truly know when a session has ended results in frustration because the next query may not be able to run because the last is actually still running.
- The tuning advisor runs very long and is not always helpful.
- Not knowing the status of a query can be frustrating. That is, if a query is running long, it may show as "running" (i.e. the horizontal bar moving back and forth at the bottom of the screen), but in actuality, it may be hung up.
For non-DBAs, the interface is relatively easy to understand, with a straightforward feeling and very few buttons. This 'plain' feeling can help non-expert users not feel intimidated or inundated.
Oracle SQL Developer paves the way
- Searches for and gathers data quickly and efficiently.
- If you error during writing your queries, this usually provides accurate reasons why your query errored, allowing you to quickly make the correct fixes.
- Allows for customization.
- I am stretching to come up with cons for SQL Developer, it could possibly have more tips and tricks for easily writing queries. Maybe more user-friendly functionality.
Oracle SQL Developer: my daily work buddy
Oracle SQL Developer is a popular tool we use here at our organization. Developers, DBAs and data architects all use this tool. We use it for running queries, DBA administration, and Data Modeling. In the DBA section, it provides database configuration - initialization parameters, current database properties, and database stats—the instance viewer is super nice.
- DBA section: automatic undo management, initialization parameters, database feature usage, instance viewer (CPU, session, top SQL, processes,etc.).
- Memory/storage: beautiful graphics, performance, backup/recovery, security (roles, users, profiles, and auditing). All is nicely displayed!
- SQL Worksheet: I can run queries in a database, hop to a different database, run the same query or different one. All can be done in one console.
- I have connections set up for 40 databases, switch between databases - very convenient. Queries can be kept in History or save to a notepad.
- Tools: 1.Modeling is a nice addition in SQL Developer. I don't use it for creating logical models. However, I find it very helpful to look at the model and understand the relationship between tables and schemas.
- Database copy: make a copy of the database from source to destination with many different options - object copy, tablespace copy, schema copy, copy DDL, copy data.
- Database diff: make comparisons between databases
- Database export with many options based on requirements.
- SQL Worksheet: listed above
- Session monitoring: who is logged in.
- Real-time SQL monitoring: insight into how to tune a poorly written query. It does, however, need an additional license.
- General: tables are nicely displayed. I used it every day. I can see column, data model, constraints, grants, statistics, triggers, dependencies, partitions, indexes and I can generate SQL DDL!
- A dashboard to display database status: all database connected/registered, general info, database up/down, version, size and which server it's on.
- Schedule jobs to be run.
SQL Developer is amazing!
- Run queries
- Export Data
- When displaying errors it locates the error on the exact line and position.
- I would like to drag and drop from and to any of the areas.
- I would like to have more capabilities to export.
- Have help info handy when I have a doubt with extensive help.
Easy-to-use tool
- User-friendly.
- Easy to install.
- Allows users to write PL/SQL.
- You can't run more than one query against the same database at one time. This is a capability for TOAD.
- Sometimes it doesn't allow you to use parallel threads in query execution and the error message isn't very descriptive or explain why.
- Editing your display preferences could be a little easier. I had to watch several YouTube videos before I was able to figure out where those settings are kept.
Oracle SQL Developer
- It's easy to navigate among the dashboard.
- It's easy to find errors when debugging.
- It's easy to run SQL scripts.
- To more easily go back to the dashboard that I had set up before.
- Finding tables and Views more easily.
- Finding certain columns and which tables or views have these.
- Easy to use.
- Beginner and power user-friendly.
- I wish that you could view multiple tables in the same database at the same time.
- I wish that you could easily open multiple databases at the same time in the same instance.
- I often misclick when opening a database, so it would be nice to either launch it faster or not immediately open (or at least have the option to enable a soft validation).
Simple SQL software that is easy to use
- Easy to use UI.
- Fairly quick software with right Java versions, etc.
- Formatting feature is good.
- Explain plan feature is great.
- Canceling queries (at least in older versions) didn't actually cancel queries; it still had to do the entire query then rollback.
- Out of sync versions of java make SQL Developer run terribly, I've had this happen on a virtual machine and I no longer use it there.
- Setting defaults for login/etc. With files isn't so simple even for newer versions.
SQL Developer is a decent, free tool
- Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
- Easily preview data columns on an Oracle table or view and the metadata on those columns.
- SQL Editor is color-coded so that you can tell easily what are keywords.
- You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.
- Memory sorting feature would be great, which SQL developer doesn't have. Basically, after you get results from your query the memory sort feature caches your results into memory and then you are able to sort your columns/filter data results without having to rerun your query.
- Easily be able to make your SQL editor screen zoomed in or zoomed out when showing your code in SQL developer with an easy hotkey rather than having to go into the SQL editor properties to change the font size.
- It would be nice to be able to view schemas, views, tables, and sequences easier. Maybe some kind of dropdown that could help navigate these options when there is a connection to the database.